import openpyxl
wb = openpyxl.load_workbook('方案中心人员团队管理-2020.xlsx')
sheet = wb.worksheets[2]
empoyeeDate = {}
for row in range(2, sheet.max_row+1):
    dept = sheet['E'+str(row)].value
    empoyeeType = sheet['F'+str(row)].value
    empoyeeDate.setdefault(dept, {'wb': 0, 'nq': 0})
    if empoyeeType == '外包':
        empoyeeDate[dept]['wb'] += 1
    else:
        empoyeeDate[dept]['nq'] += 1
print(empoyeeDate)
